package com.itheima.mapper;

import com.itheima.pojo.Member;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface MemberMapper {
    @Select("select *from health_chuanzhi.t_member where id=#{memberId}")
    Member selectById(Integer memberId);
    @Select("select *from health_chuanzhi.t_member where idCard=#{idCard}")
    Member selectByIDCard(String idCard);
@Insert("insert into health_chuanzhi.t_member( name, sex, idCard, phoneNumber, regTime)values(#{name},#{sex},#{idCard},#{phoneNumber},#{regTime}) ")
    void addMember(Member member);
}
